package shop;

import common.db.*;
import common.main.*;
import java.util.*;

public class ShopListBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String code = (String)inputTable.get("code");
		
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT a.NAME CNAME, b.KIND, b.NAME, b.PRICE, b.UNIT, b.IMAGE, b.CODE, b.GNO ");
		queryBuffer.append("FROM CATEGORY a, GOODS b ");
		queryBuffer.append("WHERE a.CODE=b.CODE AND b.DISPLAYYN='Y' AND b.USEYN='Y' AND a.CODE='"+code+"' ");
		queryBuffer.append("ORDER BY b.SEQ ");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}